SnowConvert AI - About

SnowConvert AI is an AI-powered Snowflake utility that accurately converts source database code from other platforms to Snowflake.

It ingests scripts for the source database objects such as tables, views, stored procedures, and functions. These scripts are then converted into Snowflake SQL scripts to recreate the exact equivalent Snowflake database objects. After reviewing the converted code, you can deploy the Snowflake SQL scripts on an existing instance of Snowflake.

Database platforms differ in syntax, built-in and procedural language features, logical architecture, SQL extensions, data types, and the extent of user defined customizations. SnowConvert AI intelligently detects these differences and flags them as errors, warnings, issues (EWIs), and functional difference messages (FDMs). These can be resolved manually or by using the built AI Code Conversion feature. The AI Code Conversion feature also creates test cases to verify that the functionality of the converted Snowflake SQL code is exactly the same as the source database code.

Users can deploy the converted and verified code in an existing Snowflake instance.

SnowConvert AI capabilities

Source Technology

Availability

Supported Code Conversion

Source DB Connection

Data Migration

Snowflake Deployment

AI Code Conversion

Teradata

GA

Tables, views, stored procedures, functions, Basic Teradata Query (BTEQ), Teradata MultiLoad (MLOAD), Teradata Parallel Data Pump (TPUMP)

Extraction script

No

No

No

Oracle

GA

Tables, views, stored procedures, functions, packages

Extraction script

No

No

No

SQL Server

GA

Tables, views, stored procedures, functions

Extraction script, direct DB connection

Yes

Yes

Yes

Redshift

GA

Tables, views, stored procedures, functions

Extraction script, direct DB connection

Yes

Yes

Yes

Azure Synapse

GA

Tables, views, stored procedures, functions

Extraction script

No

No

No

Sybase IQ

GA

Tables, views, stored procedures, functions

Extraction script

No

No

No

Google BigQuery

GA

Tables, views

Extraction script

No

No

Yes

Greenplum

GA

Tables, views

No

No

No

No

Netezza

GA

Tables, views

No

No

No

No

PostgreSQL

GA

Tables, views

No

No

No

Yes

Spark SQL

GA

Tables, views

No

No

No

No

Databricks SQL

GA

Tables, views

No

No

No

No

Vertica

GA

Tables, views

No

No

No

No

Hive

GA

Tables, views

No

No

No

No

IBM DB2

GA

Tables, views, stored procedures, functions

No

No

No

No

For more information, contact snowconvert-info@snowflake.com.